
/***********************************************************
* Purpose : Get All Question by Category ID
* Author : NuoiNV
* Date: 25/3/2012
* Description: Get All Question by Category ID
*/
IF EXISTS ( SELECT * FROM SYSOBJECTS WHERE NAME = 'sp_GetAllQuestion_ByCategoryID') 
BEGIN
	DROP PROC sp_GetAllQuestion_ByCategoryID
END
GO
CREATE PROC sp_GetAllQuestion_ByCategoryID
	@Category_ID int 
AS
BEGIN 
SELECT * FROM Question where Category_ID=@Category_ID
END
GO